Overview

Dataset statistics

Number of variables17
Number of observations6486
Missing cells4302
Missing cells (%)3.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory861.5 KiB
Average record size in memory136.0 B

Variable types

NUM11
CAT6

Reproduction

Analysis started2020-05-21 15:05:00.607212
Analysis finished2020-05-21 15:05:19.469604
Duration18.86 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

name has a high cardinality: 6102 distinct values High cardinality
host_name has a high cardinality: 1200 distinct values High cardinality
last_review has a high cardinality: 763 distinct values High cardinality
id is highly correlated with df_indexHigh correlation
df_index is highly correlated with idHigh correlation
neighbourhood is highly correlated with neighbourhood_groupHigh correlation
neighbourhood_group is highly correlated with neighbourhoodHigh correlation
last_review has 2151 (33.2%) missing values Missing
reviews_per_month has 2151 (33.2%) missing values Missing
name is uniformly distributed Uniform
df_index has unique values Unique
id has unique values Unique
number_of_reviews has 2151 (33.2%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count6486
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4202.673913043478
Minimum0
Maximum7906
Zeros1
Zeros (%)< 0.1%
Memory size50.7 KiB

Quantile statistics

Minimum0
5-th percentile399.25
Q12310.25
median4342.5
Q36157.75
95-th percentile7578.75
Maximum7906
Range7906
Interquartile range (IQR)3847.5

Descriptive statistics

Standard deviation2267.190666
Coefficient of variation (CV)0.5394638538
Kurtosis-1.123690576
Mean4202.673913
Median Absolute Deviation (MAD)1910
Skewness-0.155548045
Sum27258543
Variance5140153.514
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
40941< 0.1%
 
53521< 0.1%
 
32751< 0.1%
 
53281< 0.1%
 
73771< 0.1%
 
12341< 0.1%
 
32831< 0.1%
 
53361< 0.1%
 
12421< 0.1%
 
53441< 0.1%
 
Other values (6476)647699.8%
 
ValueCountFrequency (%) 
01< 0.1%
 
11< 0.1%
 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
ValueCountFrequency (%) 
79061< 0.1%
 
79051< 0.1%
 
79041< 0.1%
 
79031< 0.1%
 
79021< 0.1%
 

id
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count6486
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24477326.361856304
Minimum49091
Maximum38112762
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum49091
5-th percentile5248223.75
Q117415009
median26853730.5
Q332999241.25
95-th percentile37260394.25
Maximum38112762
Range38063671
Interquartile range (IQR)15584232.25

Descriptive statistics

Standard deviation10014574.64
Coefficient of variation (CV)0.4091367862
Kurtosis-0.6657975761
Mean24477326.36
Median Absolute Deviation (MAD)7093476
Skewness-0.6134689081
Sum1.587599388e+11
Variance1.002917053e+14
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
228904951< 0.1%
 
182594211< 0.1%
 
346967351< 0.1%
 
123776331< 0.1%
 
97389171< 0.1%
 
376048991< 0.1%
 
136433031< 0.1%
 
122138011< 0.1%
 
376847781< 0.1%
 
305106351< 0.1%
 
Other values (6476)647699.8%
 
ValueCountFrequency (%) 
490911< 0.1%
 
506461< 0.1%
 
563341< 0.1%
 
716091< 0.1%
 
718961< 0.1%
 
ValueCountFrequency (%) 
381127621< 0.1%
 
381104931< 0.1%
 
381093361< 0.1%
 
381082731< 0.1%
 
381051261< 0.1%
 

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count6102
Unique (%)94.1%
Missing0
Missing (%)0.0%
Memory size50.7 KiB
Luxury hostel with in-cabin locker - Single mixed
 
13
Inviting & Cozy 1BR APT 3 mins from Tg Pagar MRT
 
9
Studio Apartment - Oakwood Premier
 
9
Tasteful & Cozy 1 BR near SGH/Tiong Bahru
 
8
Superhost 1BR APT in the heart of Tg Pagar
 
8
Other values (6097)
6439
ValueCountFrequency (%) 
Luxury hostel with in-cabin locker - Single mixed130.2%
 
Inviting & Cozy 1BR APT 3 mins from Tg Pagar MRT90.1%
 
Studio Apartment - Oakwood Premier90.1%
 
Tasteful & Cozy 1 BR near SGH/Tiong Bahru80.1%
 
Superhost 1BR APT in the heart of Tg Pagar80.1%
 
City-located 1BR loft apartment *BRAND NEW*80.1%
 
Stylish 1BR Located 7 mins from Tg Pagar MRT70.1%
 
Single Capsule For 1 (Free Breakfast)70.1%
 
City-located studio loft apartment *BRAND NEW*60.1%
 
Spacious bedroom near city centre with free Wi-Fi60.1%
 
Other values (6092)640598.8%
 

Length

Max length92
Median length41
Mean length38.83811286
Min length1

host_id
Real number (ℝ≥0)

Distinct count1680
Unique (%)25.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean95489047.25254394
Minimum23666
Maximum288567551
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum23666
5-th percentile3454695.75
Q123336011
median66406177
Q3159804766
95-th percentile250849933.8
Maximum288567551
Range288543885
Interquartile range (IQR)136468755

Descriptive statistics

Standard deviation84151089.48
Coefficient of variation (CV)0.8812643115
Kurtosis-0.9558974453
Mean95489047.25
Median Absolute Deviation (MAD)56157733
Skewness0.6410881293
Sum6.193419605e+11
Variance7.081405861e+15
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
664061772153.3%
 
84920072013.1%
 
2099138411572.4%
 
294208531412.2%
 
314645131131.7%
 
24134121111.7%
 
2195501511091.7%
 
1087733661091.7%
 
8948251831.3%
 
23722617831.3%
 
Other values (1670)516479.6%
 
ValueCountFrequency (%) 
236661< 0.1%
 
594983< 0.1%
 
1652092< 0.1%
 
1845961< 0.1%
 
2277961< 0.1%
 
ValueCountFrequency (%) 
2885675511< 0.1%
 
2885462011< 0.1%
 
2882499751< 0.1%
 
2881104671< 0.1%
 
2880165192< 0.1%
 

host_name
Categorical

HIGH CARDINALITY

Distinct count1200
Unique (%)18.5%
Missing0
Missing (%)0.0%
Memory size50.7 KiB
Alvin
 
246
Jay
 
227
Richards
 
157
Aaron
 
144
Darcy
 
113
Other values (1195)
5599
ValueCountFrequency (%) 
Alvin2463.8%
 
Jay2273.5%
 
Richards1572.4%
 
Aaron1442.2%
 
Darcy1131.7%
 
Kaurus1111.7%
 
Rain1091.7%
 
RedDoorz1091.7%
 
Alex961.5%
 
Joey921.4%
 
Other values (1190)508278.4%
 

Length

Max length35
Median length5
Mean length5.96083873
Min length1

neighbourhood_group
Categorical

HIGH CORRELATION

Distinct count5
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size50.7 KiB
Central Region
5327
East Region
 
374
West Region
 
373
North-East Region
 
248
North Region
 
164
ValueCountFrequency (%) 
Central Region532782.1%
 
East Region3745.8%
 
West Region3735.8%
 
North-East Region2483.8%
 
North Region1642.5%
 

Length

Max length17
Median length14
Mean length13.71862473
Min length11

neighbourhood
Categorical

HIGH CORRELATION

Distinct count41
Unique (%)0.6%
Missing0
Missing (%)0.0%
Memory size50.7 KiB
Kallang
903
Geylang
890
Novena
 
489
Rochor
 
432
Outram
 
419
Other values (36)
3353
ValueCountFrequency (%) 
Kallang90313.9%
 
Geylang89013.7%
 
Novena4897.5%
 
Rochor4326.7%
 
Outram4196.5%
 
Bukit Merah3795.8%
 
Downtown Core3595.5%
 
River Valley3114.8%
 
Bedok2834.4%
 
Queenstown1993.1%
 
Other values (31)182228.1%
 

Length

Max length23
Median length7
Mean length8.3484428
Min length5

latitude
Real number (ℝ≥0)

Distinct count4162
Unique (%)64.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.3130704193647857
Minimum1.24387
Maximum1.45328
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum1.24387
5-th percentile1.278865
Q11.29549
median1.31067
Q31.3203
95-th percentile1.375195
Maximum1.45328
Range0.20941
Interquartile range (IQR)0.02481

Descriptive statistics

Standard deviation0.02947909119
Coefficient of variation (CV)0.02245050285
Kurtosis4.825492501
Mean1.313070419
Median Absolute Deviation (MAD)0.012645
Skewness1.848773173
Sum8516.57474
Variance0.0008690168176
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1.3112580.1%
 
1.3114180.1%
 
1.3113770.1%
 
1.2837670.1%
 
1.3126960.1%
 
1.2948860.1%
 
1.3152360.1%
 
1.3144160.1%
 
1.3114660.1%
 
1.3153460.1%
 
Other values (4152)642099.0%
 
ValueCountFrequency (%) 
1.243871< 0.1%
 
1.245261< 0.1%
 
1.248471< 0.1%
 
1.248531< 0.1%
 
1.248811< 0.1%
 
ValueCountFrequency (%) 
1.453281< 0.1%
 
1.452031< 0.1%
 
1.449681< 0.1%
 
1.449281< 0.1%
 
1.448931< 0.1%
 

longitude
Real number (ℝ≥0)

Distinct count4565
Unique (%)70.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean103.85008639685475
Minimum103.66547
Maximum103.97341999999999
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum103.66547
5-th percentile103.7646175
Q1103.8378425
median103.85024
Q3103.873045
95-th percentile103.9115475
Maximum103.97342
Range0.30795
Interquartile range (IQR)0.0352025

Descriptive statistics

Standard deviation0.04122036085
Coefficient of variation (CV)0.0003969217772
Kurtosis2.415018947
Mean103.8500864
Median Absolute Deviation (MAD)0.014535
Skewness-0.7976317333
Sum673571.6604
Variance0.001699118149
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
103.8536660.1%
 
103.8519260.1%
 
103.8429660.1%
 
103.8536160.1%
 
103.8452360.1%
 
103.8386360.1%
 
103.8767260.1%
 
103.8878850.1%
 
103.8516150.1%
 
103.8469150.1%
 
Other values (4555)642999.1%
 
ValueCountFrequency (%) 
103.665471< 0.1%
 
103.685361< 0.1%
 
103.686761< 0.1%
 
103.687441< 0.1%
 
103.687791< 0.1%
 
ValueCountFrequency (%) 
103.973421< 0.1%
 
103.972921< 0.1%
 
103.971051< 0.1%
 
103.968151< 0.1%
 
103.967511< 0.1%
 

room_type
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size50.7 KiB
Entire home/apt
3546
Private room
2595
Shared room
 
345
ValueCountFrequency (%) 
Entire home/apt354654.7%
 
Private room259540.0%
 
Shared room3455.3%
 

Length

Max length15
Median length15
Mean length13.58695652
Min length11

price
Real number (ℝ≥0)

Distinct count334
Unique (%)5.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean156.96793092815295
Minimum14
Maximum999
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum14
5-th percentile35
Q169
median131
Q3200
95-th percentile381
Maximum999
Range985
Interquartile range (IQR)131

Descriptive statistics

Standard deviation121.7328327
Coefficient of variation (CV)0.7755267713
Kurtosis6.951821767
Mean156.9679309
Median Absolute Deviation (MAD)66
Skewness2.126890986
Sum1018094
Variance14818.88255
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
601622.5%
 
1001462.3%
 
1311452.2%
 
2001402.2%
 
501392.1%
 
1501332.1%
 
1191221.9%
 
691211.9%
 
561061.6%
 
901061.6%
 
Other values (324)516679.6%
 
ValueCountFrequency (%) 
141< 0.1%
 
151< 0.1%
 
182< 0.1%
 
19240.4%
 
2180.1%
 
ValueCountFrequency (%) 
9993< 0.1%
 
9501< 0.1%
 
9003< 0.1%
 
8901< 0.1%
 
8871< 0.1%
 

minimum_nights
Real number (ℝ≥0)

Distinct count69
Unique (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.107924761023742
Minimum1
Maximum1000
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q315
95-th percentile90
Maximum1000
Range999
Interquartile range (IQR)13

Descriptive statistics

Standard deviation43.31019964
Coefficient of variation (CV)2.266609283
Kurtosis68.81668176
Mean19.10792476
Median Absolute Deviation (MAD)2
Skewness5.904722085
Sum123934
Variance1875.773393
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1154123.8%
 
2110817.1%
 
396214.8%
 
904737.3%
 
303745.8%
 
73375.2%
 
53184.9%
 
181802.8%
 
61752.7%
 
41662.6%
 
Other values (59)85213.1%
 
ValueCountFrequency (%) 
1154123.8%
 
2110817.1%
 
396214.8%
 
41662.6%
 
53184.9%
 
ValueCountFrequency (%) 
10001< 0.1%
 
7001< 0.1%
 
365250.4%
 
3602< 0.1%
 
3561< 0.1%
 

number_of_reviews
Real number (ℝ≥0)

ZEROS

Distinct count203
Unique (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.121800801726796
Minimum0
Maximum323
Zeros2151
Zeros (%)33.2%
Memory size50.7 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median2
Q312
95-th percentile70.75
Maximum323
Range323
Interquartile range (IQR)12

Descriptive statistics

Standard deviation30.79246766
Coefficient of variation (CV)2.180491574
Kurtosis21.56055384
Mean14.1218008
Median Absolute Deviation (MAD)2
Skewness4.074715453
Sum91594
Variance948.1760644
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0215133.2%
 
186213.3%
 
24547.0%
 
32894.5%
 
42063.2%
 
51712.6%
 
61592.5%
 
71272.0%
 
81101.7%
 
91021.6%
 
Other values (193)185528.6%
 
ValueCountFrequency (%) 
0215133.2%
 
186213.3%
 
24547.0%
 
32894.5%
 
42063.2%
 
ValueCountFrequency (%) 
3231< 0.1%
 
3071< 0.1%
 
2961< 0.1%
 
2911< 0.1%
 
2891< 0.1%
 

last_review
Categorical

HIGH CARDINALITY
MISSING

Distinct count763
Unique (%)17.6%
Missing2151
Missing (%)33.2%
Memory size50.7 KiB
2019-08-12
 
147
2019-08-11
 
122
2019-08-13
 
109
2019-08-10
 
84
2019-08-08
 
77
Other values (758)
3796
ValueCountFrequency (%) 
2019-08-121472.3%
 
2019-08-111221.9%
 
2019-08-131091.7%
 
2019-08-10841.3%
 
2019-08-08771.2%
 
2019-08-04711.1%
 
2019-08-25631.0%
 
2019-08-05621.0%
 
2019-08-24590.9%
 
2019-07-29590.9%
 
Other values (753)348253.7%
 
(Missing)215133.2%
 

Length

Max length10
Median length10
Mean length7.67853839
Min length3

reviews_per_month
Real number (ℝ≥0)

MISSING

Distinct count520
Unique (%)12.0%
Missing2151
Missing (%)33.2%
Infinite0
Infinite (%)0.0%
Mean1.1483737024221454
Minimum0.01
Maximum13.0
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum0.01
5-th percentile0.07
Q10.23
median0.66
Q31.55
95-th percentile3.963
Maximum13
Range12.99
Interquartile range (IQR)1.32

Descriptive statistics

Standard deviation1.335390003
Coefficient of variation (CV)1.162853172
Kurtosis7.313129462
Mean1.148373702
Median Absolute Deviation (MAD)0.5
Skewness2.212140844
Sum4978.2
Variance1.783266459
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11622.5%
 
0.12741.1%
 
0.08681.0%
 
0.14671.0%
 
0.16621.0%
 
0.15610.9%
 
0.1590.9%
 
0.06580.9%
 
0.07550.8%
 
0.17540.8%
 
Other values (510)361555.7%
 
(Missing)215133.2%
 
ValueCountFrequency (%) 
0.012< 0.1%
 
0.02230.4%
 
0.03450.7%
 
0.04440.7%
 
0.05430.7%
 
ValueCountFrequency (%) 
131< 0.1%
 
12.61< 0.1%
 
121< 0.1%
 
11.031< 0.1%
 
8.371< 0.1%
 

calculated_host_listings_count
Real number (ℝ≥0)

Distinct count55
Unique (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46.2104532839963
Minimum1
Maximum274
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum1
5-th percentile1
Q13
median14
Q367
95-th percentile203
Maximum274
Range273
Interquartile range (IQR)64

Descriptive statistics

Standard deviation65.78037772
Coefficient of variation (CV)1.423495617
Kurtosis3.222337907
Mean46.21045328
Median Absolute Deviation (MAD)13
Skewness1.916977448
Sum299721
Variance4327.058093
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1101015.6%
 
25107.9%
 
32854.4%
 
2742153.3%
 
2032013.1%
 
671973.0%
 
41852.9%
 
81822.8%
 
71652.5%
 
61652.5%
 
Other values (45)337152.0%
 
ValueCountFrequency (%) 
1101015.6%
 
25107.9%
 
32854.4%
 
41852.9%
 
51632.5%
 
ValueCountFrequency (%) 
2742153.3%
 
2032013.1%
 
1571572.4%
 
1411412.2%
 
1141131.7%
 

availability_365
Real number (ℝ≥0)

Distinct count358
Unique (%)5.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean253.07107616404565
Minimum1
Maximum365
Zeros0
Zeros (%)0.0%
Memory size50.7 KiB

Quantile statistics

Minimum1
5-th percentile38
Q1148
median315
Q3359
95-th percentile365
Maximum365
Range364
Interquartile range (IQR)211

Descriptive statistics

Standard deviation121.0503252
Coefficient of variation (CV)0.4783254057
Kurtosis-1.063038603
Mean253.0710762
Median Absolute Deviation (MAD)50
Skewness-0.7120982325
Sum1641419
Variance14653.18122
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
36583512.9%
 
3643295.1%
 
3621492.3%
 
3581302.0%
 
3591171.8%
 
3631161.8%
 
361841.3%
 
356801.2%
 
360801.2%
 
180671.0%
 
Other values (348)449969.4%
 
ValueCountFrequency (%) 
1150.2%
 
2190.3%
 
3160.2%
 
4110.2%
 
590.1%
 
ValueCountFrequency (%) 
36583512.9%
 
3643295.1%
 
3631161.8%
 
3621492.3%
 
361841.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

df_indexidnamehost_idhost_nameneighbourhood_groupneighbourhoodlatitudelongituderoom_typepriceminimum_nightsnumber_of_reviewslast_reviewreviews_per_monthcalculated_host_listings_countavailability_365
0049091COZICOMFORT LONG TERM STAY ROOM 2266763FrancescaNorth RegionWoodlands1.44255103.79580Private room8318012013-10-210.012365
1150646Pleasant Room along Bukit Timah227796SujathaCentral RegionBukit Timah1.33235103.78521Private room8190182014-12-260.281365
2256334COZICOMFORT266763FrancescaNorth RegionWoodlands1.44246103.79667Private room696202015-10-010.202365
3371609Ensuite Room (Room 1 & 2) near EXPO367042BelindaEast RegionTampines1.34541103.95712Private room2061142019-08-110.159353
4471896B&B Room 1 near Airport & EXPO367042BelindaEast RegionTampines1.34567103.95963Private room941222019-07-280.229355
5571903Room 2-near Airport & EXPO367042BelindaEast RegionTampines1.34702103.96103Private room1041392019-08-150.389346
66719073rd level Jumbo room 5 near EXPO367042BelindaEast RegionTampines1.34348103.96337Private room2081252019-07-250.259172
77241503Long stay at The Breezy East "Leopard"1017645BiancaEast RegionBedok1.32304103.91363Private room50901742019-05-311.88459
88241508Long stay at The Breezy East "Plumeria"1017645BiancaEast RegionBedok1.32458103.91163Private room54901982019-04-282.084133
99241510Long stay at The Breezy East "Red Palm"1017645BiancaEast RegionBedok1.32461103.91191Private room42902362019-07-312.534147

Last rows

df_indexidnamehost_idhost_nameneighbourhood_groupneighbourhoodlatitudelongituderoom_typepriceminimum_nightsnumber_of_reviewslast_reviewreviews_per_monthcalculated_host_listings_countavailability_365
6476789738092051New Small Room @Orchard/Somerset/Central Area262337792HermanCentral RegionRiver Valley1.29482103.83809Private room4090NaNNaN11258
6477789838092142Well connected 2 bedroom 2 bathroom apartment !223622603TanyaCentral RegionRochor1.30082103.84956Entire home/apt20020NaNNaN4347
6478789938094671SMALL ROOM FOR ONE @SOMERSET/ORCHARD/CENTRAL AREA262337792HermanCentral RegionRiver Valley1.29369103.83768Private room3370NaNNaN11359
6479790038102097环境优雅的公寓286260560BoWest RegionBukit Batok1.35654103.76028Private room9030NaNNaN183
64807901381049712 PAX LOFT Close To Kent Ridge Park278109833BelleCentral RegionQueenstown1.27973103.78751Entire home/apt10030NaNNaN3161
6481790238105126Loft 2 pax near Haw Par / Pasir Panjang. Free Wifi278109833BelleCentral RegionQueenstown1.27973103.78751Entire home/apt10030NaNNaN3161
64827903381082733bedroom luxury at Orchard238891646NehaCentral RegionTanglin1.29269103.82623Entire home/apt55060NaNNaN34365
6483790438109336[ Farrer Park ] New City Fringe CBD Mins to MRT281448565MindyCentral RegionKallang1.31286103.85996Private room58300NaNNaN3173
6484790538110493Cheap Master Room in Central of Singapore243835202HuangCentral RegionRiver Valley1.29543103.83801Private room56140NaNNaN230
6485790638112762Amazing room with private bathroom walk to Orchard28788520TerenceCentral RegionRiver Valley1.29672103.83325Private room65900NaNNaN7365